-- @owner: @zou_jialiang050
-- @date: 2022/09/15
-- @testpoint: show create function指定返回record类型函数

--step1:创建函数;expect:成功
drop function if exists f_show_create_function_0002;
create or replace function f_show_create_function_0002(i int, out result_1 bigint, out result_2 bigint)
returns setof record
as $$
begin
    result_1 = i + 1;
    result_2 = i * 10;
return next;
end;
$$language plpgsql;
/

--step2:show create function指定返回record类型函数;expect:成功
show create function f_show_create_function_0002;

--step3:清理环境;expect:成功
drop function if exists f_show_create_function_0002;